+ Reply to Thread + Post New Thread
Results 1 to 2 of 2

Thread: Dynamic Key Word [insetion] yea......

  1. #1
    Noobie
    Join Date
    Apr 2008
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Dynamic Key Word [insetion] yea......

    So I got a list of 2000 top populated cities in USA.
    What I want to do is use them as keywords, and ad
    a word in front of the city name or after.

    For example

    I got
    New york
    Atlanta
    Chicago
    Denver
    Francisco
    List goes on


    I need to convert them to: Example
    Cars in New york
    Cars in Atlanta
    Cars in Chicago
    Cars in Denver
    Cars in Francisco
    List goes on

    or the keyword after the city name.

    I looked all over the place for a tool that would do
    that automatically,
    but no luck.

    If you know how this can be done please enlighten me.

    Thanx alot

  2. #2
    Noobie
    Join Date
    Apr 2008
    Posts
    606
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    you could use excel...

    paste your city names in one column and then in the next column

    type
    Code:
     ="Cars in "&A1
    this would display

    Cars in New York

    providing the first cell was of course New York

    copy and paste the new cell by dragging and it will auto-populate for your full 2000 cities... hope that makes sense

    once you completed this you would select the column and paste it into notepad or whatever you wanted to use the list for....

    i have a tool that does this for you using php but its not quite ready to launch just yet

    i think this would work in google apps too and microsoft works...

    hth

    pm if you still need a hand

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts